TG: sql_for_qa/64

SQL для тестировщика

Какой из следующих SQL запросов вернет топ-5 самых просматриваемых постов из таблицы posts, отсортированных по количеству просмотров в порядке убывания?

Anonymous Quiz

SELECT * FROM posts ORDER BY views DESC LIMIT 5;

SELECT TOP 5 * FROM posts ORDER BY views DESC;

SELECT * FROM posts WHERE ROWNUM <= 5 ORDER BY views DESC;

SELECT * FROM posts WHERE views >= 5 ORDER BY views DESC LIMIT 5;

641 answered

www.tg-me.com/de/SQL для тестировщика/com.sql_for_qa/64

2.6K viewsMar 17, 2023 at 11:02

tg-me.com/sql_for_qa/64

Create: 2023-03-17
Last Update: 2025-07-02 10:48:54

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/64

SQL для тестировщика Telegram | DID YOU KNOW?

What is Telegram?

Telegram’s stand out feature is its encryption scheme that keeps messages and media secure in transit. The scheme is known as MTProto and is based on 256-bit AES encryption, RSA encryption, and Diffie-Hellman key exchange. The result of this complicated and technical-sounding jargon? A messaging service that claims to keep your data safe.Why do we say claims? When dealing with security, you always want to leave room for scrutiny, and a few cryptography experts have criticized the system. Overall, any level of encryption is better than none, but a level of discretion should always be observed with any online connected system, even Telegram.

However, analysts are positive on the stock now. “We have seen a huge downside movement in the stock due to the central electricity regulatory commission’s (CERC) order that seems to be negative from 2014-15 onwards but we cannot take a linear negative view on the stock and further downside movement on the stock is unlikely. Currently stock is underpriced. Investors can bet on it for a longer horizon," said Vivek Gupta, director research at CapitalVia Global Research.